if object_id('ExamInsert') is not null
	drop proc ExamInsert
	
go

create proc ExamInsert
	@CUnitID int,
	@ExamDate datetime,
	@ExamEndDate datetime,
	@ExamSeasonId int,
	@Scheduled bit
as
begin
	insert into Exams (CUnitID, ExamDate, ExamEndDate, ExamSeasonId, Scheduled)
	 values (@CUnitID, @ExamDate, @ExamEndDate, @ExamSeasonId, @Scheduled)
	select scope_identity()
end	


